A Data-Warehouse is a repository that fetches data from many diverse sources within an organization for Business-Reporting and Business-Analysis. The reports created from intricate queries within a Data-Warehouse are used to improve business process, make optimal judgements, and even announce viable advantages. Since the Organizational Data is increasing exponentially day by day hence in-house Data warehouse is getting obsolete and a new concept of Cloud Based Data Warehouse is emerging. The leading player in this cloud based Data-Warehouse is AWS Redshift. After the data is collated inside the Data-Warehouse, the next step is to retrieve some analytical data and use it to boost business acumen and subsequently increase business revenue and efficiency. The above business analytics can be performed using various tools. The market leader in this regard is Microsoft Power BI. In this paper, we will try to analyze the working of Microsoft Power BI in coordination with AWS Redshift.
Amazon Web Service (AWS), Redshift, Power BI, Data-Warehouse
International Journal of Trend in Scientific Research and Development - IJTSRD having
online ISSN 2456-6470. IJTSRD is a leading Open Access, Peer-Reviewed International
Journal which provides rapid publication of your research articles and aims to promote
the theory and practice along with knowledge sharing between researchers, developers,
engineers, students, and practitioners working in and around the world in many areas
like Sciences, Technology, Innovation, Engineering, Agriculture, Management and
many more and it is recommended by all Universities, review articles and short communications
in all subjects. IJTSRD running an International Journal who are proving quality
publication of peer reviewed and refereed international journals from diverse fields
that emphasizes new research, development and their applications. IJTSRD provides
an online access to exchange your research work, technical notes & surveying results
among professionals throughout the world in e-journals. IJTSRD is a fastest growing
and dynamic professional organization. The aim of this organization is to provide
access not only to world class research resources, but through its professionals
aim to bring in a significant transformation in the real of open access journals
and online publishing.